SELECT  DATA_DIGITACAO, LANCAMENTO, CONTA_CONTABIL, RATEIO_CENTRO_CUSTO, RATEIO_FILIAL
FROM CTB_LANCAMENTO_ITEM  
WHERE RATEIO_CENTRO_CUSTO = '99.9999'
AND DATA_DIGITACAO BETWEEN '20060701' AND '20060731'
AND CONTA_CONTABIL NOT LIKE '1%'
AND CONTA_CONTABIL NOT LIKE '2%'
